<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="unit.EscapeUnescape"%>
<%@ page import="websql.DBcon"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");
String qname=request.getParameter("qname");
String cname=request.getParameter("cname");
String qsql=request.getParameter("qsql");
int cid=websql.Conn.getcid("cname",EscapeUnescape.escape(cname));

String sql="insert into query (qname,cid,qsql) values ('"+
		EscapeUnescape.escape(qname)+"','"+
		cid+"','"+
		EscapeUnescape.escape(qsql)+"')"; 
DBcon.exsql(sql);
%>

</body>
</html>